Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 810 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 82.4 KiB |
| Average record size in memory | 104.2 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 1 |
unpaid has constant value "2363179471491548.0" | Constant |
df_index is highly correlated with relative_hour | High correlation |
memory_usage is highly correlated with cpu_temp and 4 other fields | High correlation |
cpu_temp is highly correlated with memory_usage and 3 other fields | High correlation |
gpu_memory_usage is highly correlated with memory_usage and 3 other fields | High correlation |
gpu_load is highly correlated with memory_usage and 4 other fields | High correlation |
gpu_temp is highly correlated with memory_usage and 4 other fields | High correlation |
reported_hashrate is highly correlated with memory_usage and 4 other fields | High correlation |
relative_hour is highly correlated with df_index | High correlation |
df_index is uniformly distributed | Uniform |
relative_hour is uniformly distributed | Uniform |
df_index has unique values | Unique |
ts has unique values | Unique |
relative_hour has unique values | Unique |
gpu_load has 232 (28.6%) zeros | Zeros |
reported_hashrate has 232 (28.6%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-01 03:33:19.492676 |
|---|---|
| Analysis finished | 2021-12-01 03:33:38.410795 |
| Duration | 18.92 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 810 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 698.5 |
| Minimum | 294 |
|---|---|
| Maximum | 1103 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 294 |
|---|---|
| 5-th percentile | 334.45 |
| Q1 | 496.25 |
| median | 698.5 |
| Q3 | 900.75 |
| 95-th percentile | 1062.55 |
| Maximum | 1103 |
| Range | 809 |
| Interquartile range (IQR) | 404.5 |
Descriptive statistics
| Standard deviation | 233.9711521 |
|---|---|
| Coefficient of variation (CV) | 0.3349622793 |
| Kurtosis | -1.2 |
| Mean | 698.5 |
| Median Absolute Deviation (MAD) | 202.5 |
| Skewness | 0 |
| Sum | 565785 |
| Variance | 54742.5 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 294 | 1 | 0.1% |
| 837 | 1 | 0.1% |
| 827 | 1 | 0.1% |
| 828 | 1 | 0.1% |
| 829 | 1 | 0.1% |
| 830 | 1 | 0.1% |
| 831 | 1 | 0.1% |
| 832 | 1 | 0.1% |
| 833 | 1 | 0.1% |
| 834 | 1 | 0.1% |
| Other values (800) | 800 |
| Value | Count | Frequency (%) |
| 294 | 1 | |
| 295 | 1 | |
| 296 | 1 | |
| 297 | 1 | |
| 298 | 1 |
| Value | Count | Frequency (%) |
| 1103 | 1 | |
| 1102 | 1 | |
| 1101 | 1 | |
| 1100 | 1 | |
| 1099 | 1 |
| Distinct | 810 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.5 KiB |
| Minimum | 2021-11-05 14:31:06-05:00 |
|---|---|
| Maximum | 2021-11-05 16:51:07-05:00 |
Histogram with fixed size bins (bins=50)
cpu_load
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2237037037 |
| Minimum | 0.1 |
|---|---|
| Maximum | 1.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.1 |
| median | 0.2 |
| Q3 | 0.3 |
| 95-th percentile | 0.4 |
| Maximum | 1.8 |
| Range | 1.7 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.1518932392 |
|---|---|
| Coefficient of variation (CV) | 0.6789929565 |
| Kurtosis | 29.47512796 |
| Mean | 0.2237037037 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 4.098883739 |
| Sum | 181.2 |
| Variance | 0.0230715561 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0.2 | 295 | |
| 0.1 | 252 | |
| 0.3 | 207 | |
| 0.4 | 16 | 2.0% |
| 0.5 | 12 | 1.5% |
| 0.7 | 10 | 1.2% |
| 0.6 | 9 | 1.1% |
| 0.8 | 4 | 0.5% |
| 1.5 | 2 | 0.2% |
| 1.2 | 1 | 0.1% |
| Other values (2) | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 0.1 | 252 | |
| 0.2 | 295 | |
| 0.3 | 207 | |
| 0.4 | 16 | 2.0% |
| 0.5 | 12 | 1.5% |
| Value | Count | Frequency (%) |
| 1.8 | 1 | 0.1% |
| 1.5 | 2 | |
| 1.2 | 1 | 0.1% |
| 0.9 | 1 | 0.1% |
| 0.8 | 4 |
cpu_freq
Real number (ℝ≥0)
| Distinct | 790 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 927.9748395 |
| Minimum | 808.29 |
|---|---|
| Maximum | 3593.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 808.29 |
|---|---|
| 5-th percentile | 816.498 |
| Q1 | 834.765 |
| median | 861.065 |
| Q3 | 911.1125 |
| 95-th percentile | 1191.525 |
| Maximum | 3593.75 |
| Range | 2785.46 |
| Interquartile range (IQR) | 76.3475 |
Descriptive statistics
| Standard deviation | 275.8411266 |
|---|---|
| Coefficient of variation (CV) | 0.2972506525 |
| Kurtosis | 52.41213246 |
| Mean | 927.9748395 |
| Median Absolute Deviation (MAD) | 32.42 |
| Skewness | 6.64451306 |
| Sum | 751659.62 |
| Variance | 76088.32712 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 887.66 | 3 | 0.4% |
| 910.94 | 2 | 0.2% |
| 1097.96 | 2 | 0.2% |
| 873.01 | 2 | 0.2% |
| 853.71 | 2 | 0.2% |
| 1098 | 2 | 0.2% |
| 854.95 | 2 | 0.2% |
| 851.41 | 2 | 0.2% |
| 892.12 | 2 | 0.2% |
| 846.57 | 2 | 0.2% |
| Other values (780) | 789 |
| Value | Count | Frequency (%) |
| 808.29 | 1 | |
| 808.53 | 1 | |
| 808.58 | 1 | |
| 808.64 | 1 | |
| 808.78 | 1 |
| Value | Count | Frequency (%) |
| 3593.75 | 1 | |
| 3593.21 | 1 | |
| 3593.12 | 1 | |
| 3592.75 | 1 | |
| 3006.56 | 1 |
| Distinct | 680 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1340648693 |
| Minimum | 1235804160 |
|---|---|
| Maximum | 1387003904 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 1235804160 |
|---|---|
| 5-th percentile | 1237534720 |
| Q1 | 1238943744 |
| median | 1380288512 |
| Q3 | 1383370752 |
| 95-th percentile | 1385527501 |
| Maximum | 1387003904 |
| Range | 151199744 |
| Interquartile range (IQR) | 144427008 |
Descriptive statistics
| Standard deviation | 65203082.51 |
|---|---|
| Coefficient of variation (CV) | 0.0486354724 |
| Kurtosis | -1.120239848 |
| Mean | 1340648693 |
| Median Absolute Deviation (MAD) | 3704832 |
| Skewness | -0.9367020791 |
| Sum | 1.085925442 × 1012 |
| Variance | 4.251441969 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1237917696 | 6 | 0.7% |
| 1238433792 | 5 | 0.6% |
| 1380110336 | 4 | 0.5% |
| 1238888448 | 4 | 0.5% |
| 1385209856 | 3 | 0.4% |
| 1239474176 | 3 | 0.4% |
| 1238151168 | 3 | 0.4% |
| 1238683648 | 3 | 0.4% |
| 1237426176 | 3 | 0.4% |
| 1384329216 | 3 | 0.4% |
| Other values (670) | 773 |
| Value | Count | Frequency (%) |
| 1235804160 | 2 | |
| 1236279296 | 1 | |
| 1236303872 | 1 | |
| 1236320256 | 2 | |
| 1236328448 | 1 |
| Value | Count | Frequency (%) |
| 1387003904 | 1 | |
| 1386729472 | 1 | |
| 1386721280 | 1 | |
| 1386565632 | 1 | |
| 1386360832 | 1 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.00617284 |
| Minimum | 26 |
|---|---|
| Maximum | 35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 26 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 31 |
| median | 33 |
| Q3 | 34 |
| 95-th percentile | 34 |
| Maximum | 35 |
| Range | 9 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.369712352 |
|---|---|
| Coefficient of variation (CV) | 0.07403922875 |
| Kurtosis | -0.4589432815 |
| Mean | 32.00617284 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.006907634 |
| Sum | 25925 |
| Variance | 5.615536633 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 33 | 286 | |
| 34 | 218 | |
| 28 | 97 | 12.0% |
| 32 | 65 | 8.0% |
| 27 | 47 | 5.8% |
| 29 | 35 | 4.3% |
| 35 | 24 | 3.0% |
| 31 | 19 | 2.3% |
| 30 | 18 | 2.2% |
| 26 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 26 | 1 | 0.1% |
| 27 | 47 | |
| 28 | 97 | |
| 29 | 35 | 4.3% |
| 30 | 18 | 2.2% |
| Value | Count | Frequency (%) |
| 35 | 24 | 3.0% |
| 34 | 218 | |
| 33 | 286 | |
| 32 | 65 | 8.0% |
| 31 | 19 | 2.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2177081971 |
| Minimum | 9437184 |
|---|---|
| Maximum | 3052404736 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 9437184 |
|---|---|
| 5-th percentile | 9437184 |
| Q1 | 9437184 |
| median | 3052404736 |
| Q3 | 3052404736 |
| 95-th percentile | 3052404736 |
| Maximum | 3052404736 |
| Range | 3042967552 |
| Interquartile range (IQR) | 3042967552 |
Descriptive statistics
| Standard deviation | 1378308449 |
|---|---|
| Coefficient of variation (CV) | 0.6330990137 |
| Kurtosis | -1.119291326 |
| Mean | 2177081971 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.9399353536 |
| Sum | 1.763436397 × 1012 |
| Variance | 1.899734179 × 1018 |
| Monotonicity | Decreasing |
Histogram with fixed size bins (bins=2)
| Value | Count | Frequency (%) |
| 3052404736 | 577 | |
| 9437184 | 233 |
| Value | Count | Frequency (%) |
| 9437184 | 233 | |
| 3052404736 | 577 |
| Value | Count | Frequency (%) |
| 3052404736 | 577 | |
| 9437184 | 233 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.34567901 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 232 |
| Zeros (%) | 28.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 100 |
Descriptive statistics
| Standard deviation | 45.23026118 |
|---|---|
| Coefficient of variation (CV) | 0.6339593624 |
| Kurtosis | -1.106772296 |
| Mean | 71.34567901 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.9464282946 |
| Sum | 57790 |
| Variance | 2045.776526 |
| Monotonicity | Decreasing |
Histogram with fixed size bins (bins=3)
| Value | Count | Frequency (%) |
| 100 | 577 | |
| 0 | 232 | |
| 90 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 232 | |
| 90 | 1 | 0.1% |
| 100 | 577 |
| Value | Count | Frequency (%) |
| 100 | 577 | |
| 90 | 1 | 0.1% |
| 0 | 232 |
| Distinct | 30 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.14691358 |
| Minimum | 30 |
|---|---|
| Maximum | 66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 30 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 37.25 |
| median | 65 |
| Q3 | 66 |
| 95-th percentile | 66 |
| Maximum | 66 |
| Range | 36 |
| Interquartile range (IQR) | 28.75 |
Descriptive statistics
| Standard deviation | 14.82670882 |
|---|---|
| Coefficient of variation (CV) | 0.2640698816 |
| Kurtosis | -0.8937938009 |
| Mean | 56.14691358 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.024816381 |
| Sum | 45479 |
| Variance | 219.8312945 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 65 | 367 | |
| 66 | 210 | |
| 31 | 99 | 12.2% |
| 30 | 46 | 5.7% |
| 32 | 22 | 2.7% |
| 33 | 13 | 1.6% |
| 34 | 8 | 1.0% |
| 35 | 6 | 0.7% |
| 36 | 6 | 0.7% |
| 39 | 4 | 0.5% |
| Other values (20) | 29 | 3.6% |
| Value | Count | Frequency (%) |
| 30 | 46 | |
| 31 | 99 | |
| 32 | 22 | 2.7% |
| 33 | 13 | 1.6% |
| 34 | 8 | 1.0% |
| Value | Count | Frequency (%) |
| 66 | 210 | |
| 65 | 367 | |
| 64 | 1 | 0.1% |
| 60 | 1 | 0.1% |
| 58 | 1 | 0.1% |
hashrate
Real number (ℝ≥0)
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2386831.273 |
| Minimum | 1111111.11 |
|---|---|
| Maximum | 3333333.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 1111111.11 |
|---|---|
| 5-th percentile | 1111111.11 |
| Q1 | 2222222.22 |
| median | 2222222.22 |
| Q3 | 3333333.33 |
| 95-th percentile | 3333333.33 |
| Maximum | 3333333.33 |
| Range | 2222222.22 |
| Interquartile range (IQR) | 1111111.11 |
Descriptive statistics
| Standard deviation | 709882.3481 |
|---|---|
| Coefficient of variation (CV) | 0.2974162254 |
| Kurtosis | -0.6079048716 |
| Mean | 2386831.273 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.1396926795 |
| Sum | 1933333331 |
| Variance | 5.039329481 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=3)
| Value | Count | Frequency (%) |
| 2222222.22 | 462 | |
| 3333333.33 | 234 | |
| 1111111.11 | 114 | 14.1% |
| Value | Count | Frequency (%) |
| 1111111.11 | 114 | 14.1% |
| 2222222.22 | 462 | |
| 3333333.33 | 234 |
| Value | Count | Frequency (%) |
| 3333333.33 | 234 | |
| 2222222.22 | 462 | |
| 1111111.11 | 114 | 14.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.363179471 × 1015 |
| Minimum | 2.363179471 × 1015 |
|---|---|
| Maximum | 2.363179471 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 2.363179471 × 1015 |
|---|---|
| 5-th percentile | 2.363179471 × 1015 |
| Q1 | 2.363179471 × 1015 |
| median | 2.363179471 × 1015 |
| Q3 | 2.363179471 × 1015 |
| 95-th percentile | 2.363179471 × 1015 |
| Maximum | 2.363179471 × 1015 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | 0 |
| Kurtosis | 0 |
| Mean | 2.363179471 × 1015 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 1.914175372 × 1018 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 2.363179471 × 1015 | 810 |
| Value | Count | Frequency (%) |
| 2.363179471 × 1015 | 810 |
| Value | Count | Frequency (%) |
| 2.363179471 × 1015 | 810 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 977435.8025 |
| Minimum | 0 |
|---|---|
| Maximum | 1370000 |
| Zeros | 232 |
| Zeros (%) | 28.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1370000 |
| Q3 | 1370000 |
| 95-th percentile | 1370000 |
| Maximum | 1370000 |
| Range | 1370000 |
| Interquartile range (IQR) | 1370000 |
Descriptive statistics
| Standard deviation | 619654.5782 |
|---|---|
| Coefficient of variation (CV) | 0.6339593624 |
| Kurtosis | -1.106772296 |
| Mean | 977435.8025 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.9464282946 |
| Sum | 791723000 |
| Variance | 3.839717962 × 1011 |
| Monotonicity | Decreasing |
Histogram with fixed size bins (bins=3)
| Value | Count | Frequency (%) |
| 1370000 | 577 | |
| 0 | 232 | |
| 1233000 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 232 | |
| 1233000 | 1 | 0.1% |
| 1370000 | 577 |
| Value | Count | Frequency (%) |
| 1370000 | 577 | |
| 1233000 | 1 | 0.1% |
| 0 | 232 |
| Distinct | 810 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.013769547 |
| Minimum | 0.8469444444 |
|---|---|
| Maximum | 3.180555556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0.8469444444 |
|---|---|
| 5-th percentile | 0.9635972222 |
| Q1 | 1.430694444 |
| median | 2.013888889 |
| Q3 | 2.597013889 |
| 95-th percentile | 3.063625 |
| Maximum | 3.180555556 |
| Range | 2.333611111 |
| Interquartile range (IQR) | 1.166319444 |
Descriptive statistics
| Standard deviation | 0.6747170374 |
|---|---|
| Coefficient of variation (CV) | 0.3350517632 |
| Kurtosis | -1.199311354 |
| Mean | 2.013769547 |
| Median Absolute Deviation (MAD) | 0.5838888889 |
| Skewness | -0.0001749758104 |
| Sum | 1631.153333 |
| Variance | 0.4552430806 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.8469444444 | 1 | 0.1% |
| 2.413055556 | 1 | 0.1% |
| 2.384166667 | 1 | 0.1% |
| 2.386944444 | 1 | 0.1% |
| 2.39 | 1 | 0.1% |
| 2.392777778 | 1 | 0.1% |
| 2.395833333 | 1 | 0.1% |
| 2.398611111 | 1 | 0.1% |
| 2.401388889 | 1 | 0.1% |
| 2.404444444 | 1 | 0.1% |
| Other values (800) | 800 |
| Value | Count | Frequency (%) |
| 0.8469444444 | 1 | |
| 0.85 | 1 | |
| 0.8527777778 | 1 | |
| 0.8555555556 | 1 | |
| 0.8586111111 | 1 |
| Value | Count | Frequency (%) |
| 3.180555556 | 1 | |
| 3.1775 | 1 | |
| 3.174722222 | 1 | |
| 3.171944444 | 1 | |
| 3.168888889 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 294 | 2021-11-05 14:31:06-05:00 | 0.2 | 958.45 | 1382092800 | 33.0 | 3.052405e+09 | 100.0 | 65.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.846944 |
| 1 | 295 | 2021-11-05 14:31:17-05:00 | 0.2 | 903.91 | 1381965824 | 35.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.850000 |
| 2 | 296 | 2021-11-05 14:31:27-05:00 | 0.2 | 819.56 | 1381175296 | 34.0 | 3.052405e+09 | 100.0 | 65.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.852778 |
| 3 | 297 | 2021-11-05 14:31:37-05:00 | 0.2 | 960.24 | 1382641664 | 34.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.855556 |
| 4 | 298 | 2021-11-05 14:31:48-05:00 | 0.1 | 895.10 | 1382821888 | 34.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.858611 |
| 5 | 299 | 2021-11-05 14:31:58-05:00 | 0.3 | 827.88 | 1382850560 | 33.0 | 3.052405e+09 | 100.0 | 65.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.861389 |
| 6 | 300 | 2021-11-05 14:32:08-05:00 | 0.2 | 946.81 | 1382375424 | 34.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.864167 |
| 7 | 301 | 2021-11-05 14:32:19-05:00 | 0.3 | 1297.41 | 1382363136 | 33.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.867222 |
| 8 | 302 | 2021-11-05 14:32:29-05:00 | 0.2 | 931.95 | 1382862848 | 33.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.870000 |
| 9 | 303 | 2021-11-05 14:32:39-05:00 | 0.3 | 830.37 | 1382072320 | 33.0 | 3.052405e+09 | 100.0 | 66.0 | 2222222.22 | 2.363179e+15 | 1370000.0 | 0.872778 |
Last rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 800 | 1094 | 2021-11-05 16:49:33-05:00 | 0.1 | 815.68 | 1238151168 | 27.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.154444 |
| 801 | 1095 | 2021-11-05 16:49:44-05:00 | 0.1 | 808.29 | 1238151168 | 27.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.157500 |
| 802 | 1096 | 2021-11-05 16:49:54-05:00 | 0.1 | 828.76 | 1237884928 | 28.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.160278 |
| 803 | 1097 | 2021-11-05 16:50:04-05:00 | 0.1 | 845.28 | 1237917696 | 28.0 | 9437184.0 | 0.0 | 31.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.163056 |
| 804 | 1098 | 2021-11-05 16:50:15-05:00 | 0.1 | 921.35 | 1237917696 | 28.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.166111 |
| 805 | 1099 | 2021-11-05 16:50:25-05:00 | 0.1 | 861.53 | 1237917696 | 28.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.168889 |
| 806 | 1100 | 2021-11-05 16:50:36-05:00 | 0.1 | 830.31 | 1237909504 | 27.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.171944 |
| 807 | 1101 | 2021-11-05 16:50:46-05:00 | 0.5 | 1098.15 | 1237393408 | 27.0 | 9437184.0 | 0.0 | 31.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.174722 |
| 808 | 1102 | 2021-11-05 16:50:56-05:00 | 0.5 | 824.40 | 1237135360 | 27.0 | 9437184.0 | 0.0 | 31.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.177500 |
| 809 | 1103 | 2021-11-05 16:51:07-05:00 | 0.1 | 814.65 | 1237377024 | 27.0 | 9437184.0 | 0.0 | 30.0 | 1111111.11 | 2.363179e+15 | 0.0 | 3.180556 |